iLoADER

HOME

Expression based dynamic fields example

An Expression based dynamic field allows you to combine and manipulate data (usually from separate fields) using standard operators.

An Expression script is written in the following format:

EXPRESSION, Full Table Name, Dynamic Field Name, {Expression}

If you are using the Data Transformation wizard, these entries relate to the column fields as follows:

EXPRESSION Data Transformation function
Full Table Name Parent Table
DynamicFieldname Name of expression
{Expression} NucEngine Expression

The following example creates an Expression based dynamic field that generates a salutation by combining the [Title] and [Surname] fields.

EXPRESSION, [Demo].[Customer], Salutation,

{“Dear “ [Demo].[Customer].[Title] + “ “ + [Demo].[Customer].[Surname]}

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice